/*
 Navicat Premium Data Transfer

 Source Server         : localhost
 Source Server Type    : MySQL
 Source Server Version : 50722
 Source Host           : localhost:3306
 Source Schema         : blq_sso

 Target Server Type    : MySQL
 Target Server Version : 50722
 File Encoding         : 65001

 Date: 10/08/2018 12:24:05
*/

SET NAMES utf8mb4;
SET FOREIGN_KEY_CHECKS = 0;

-- ----------------------------
-- Table structure for sys_app
-- ----------------------------
DROP TABLE IF EXISTS `sys_app`;
CREATE TABLE `sys_app` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `code` varchar(45) DEFAULT NULL COMMENT '应用code',
  `name` varchar(45) DEFAULT NULL COMMENT '应用名称',
  `num` tinyint(3) DEFAULT NULL COMMENT '排序',
  `gmt_create` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=3 DEFAULT CHARSET=utf8 COMMENT='应用表';

-- ----------------------------
-- Records of sys_app
-- ----------------------------
BEGIN;
INSERT INTO `sys_app` VALUES (1, 'easonji., '便利圈统一权限管理系统', 1, '2018-07-31 16:38:49', '2018-07-31 16:38:49');
INSERT INTO `sys_app` VALUES (6, 'blqmech-platform', '便利圈无人超市管理系统', 2, '2018-08-02 18:48:28', '2018-08-02 18:48:28');
COMMIT;

-- ----------------------------
-- Table structure for sys_dept
-- ----------------------------
DROP TABLE IF EXISTS `sys_dept`;
CREATE TABLE `sys_dept` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `parent_id` int(11) DEFAULT NULL COMMENT '父部门ID',
  `all_parent_id` varchar(45) DEFAULT NULL COMMENT '全部父部门ID',
  `name` varchar(45) DEFAULT NULL COMMENT '部门名称',
  `num` tinyint(3) DEFAULT NULL COMMENT '排序',
  `gmt_create` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='部门表';

-- ----------------------------
-- Records of sys_dept
-- ----------------------------
BEGIN;
INSERT INTO `sys_dept` VALUES (1, 0, '[0],', '系统管理员', 1, '2018-07-31 16:33:44', '2018-07-31 16:33:44');
COMMIT;

-- ----------------------------
-- Table structure for sys_login_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_login_log`;
CREATE TABLE `sys_login_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `log_name` varchar(45) DEFAULT '' COMMENT '日志名称',
  `user_id` int(11) DEFAULT NULL COMMENT '管理员id',
  `succeed` varchar(45) DEFAULT '' COMMENT '是否执行成功',
  `message` text COMMENT '具体消息',
  `login_ip` varchar(45) DEFAULT '' COMMENT '登录ip',
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='登录记录';

-- ----------------------------
-- Table structure for sys_operation_log
-- ----------------------------
DROP TABLE IF EXISTS `sys_operation_log`;
CREATE TABLE `sys_operation_log` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `log_type` varchar(45) DEFAULT NULL COMMENT '日志类型',
  `log_name` varchar(45) DEFAULT NULL COMMENT '日志名称',
  `user_id` int(11) DEFAULT NULL COMMENT '用户id',
  `class_name` varchar(100) DEFAULT NULL COMMENT '类名称',
  `method_name` text COMMENT '方法名称',
  `succeed` varchar(45) DEFAULT NULL COMMENT '是否成功',
  `message` text COMMENT '消息',
  `gmt_create` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime NOT NULL DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=1 DEFAULT CHARSET=utf8 COMMENT='操作日志';

-- ----------------------------
-- Table structure for sys_permission
-- ----------------------------
DROP TABLE IF EXISTS `sys_permission`;
CREATE TABLE `sys_permission` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `app_id` int(11) DEFAULT NULL COMMENT '应用ID',
  `parent_id` int(11) DEFAULT NULL COMMENT '父权限ID',
  `all_parent_id` varchar(45) DEFAULT NULL COMMENT '全部父权限ID',
  `name` varchar(45) DEFAULT NULL COMMENT '权限名称',
  `url` varchar(45) DEFAULT NULL COMMENT '权限地址',
  `is_menu` tinyint(3) unsigned DEFAULT NULL COMMENT '是否是菜单',
  `icon` varchar(32) DEFAULT NULL COMMENT '图标',
  `num` tinyint(3) DEFAULT NULL COMMENT '排序',
  `gmt_create` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8 COMMENT='权限表';

-- ----------------------------
-- Records of sys_permission
-- ----------------------------
BEGIN;
INSERT INTO `sys_permission` VALUES (1, 1, 0, '[0],', '主页', '/home', 1, 'fa-home', 1, '2018-07-31 16:35:52', '2018-07-31 16:35:52');
INSERT INTO `sys_permission` VALUES (2, 1, 0, '[0],', '系统管理', '#', 1, 'fa-user', 2, '2018-07-31 16:36:39', '2018-07-31 16:36:39');
INSERT INTO `sys_permission` VALUES (3, 1, 2, '[0],[2],', '用户管理', '/user', 1, '', 1, '2018-07-31 16:37:10', '2018-07-31 18:47:13');
INSERT INTO `sys_permission` VALUES (4, 1, 2, '[0],[2],', '部门管理', '/dept', 1, '', 2, '2018-07-31 16:37:10', '2018-07-31 18:47:13');
INSERT INTO `sys_permission` VALUES (5, 1, 2, '[0],[2],', '角色管理', '/role', 1, '', 3, '2018-07-31 16:37:10', '2018-07-31 18:47:13');
INSERT INTO `sys_permission` VALUES (6, 1, 2, '[0],[2],', '权限管理', '/permission', 1, '', 4, '2018-07-31 16:37:10', '2018-07-31 18:47:13');
INSERT INTO `sys_permission` VALUES (7, 1, 2, '[0],[2],', '应用管理', '/app', 1, '', 5, '2018-07-31 16:37:10', '2018-07-31 18:47:13');
INSERT INTO `sys_permission` VALUES (8, 1, 2, '[0],[2],', '登录日志', '/loginLog', 1, '', 6, '2018-07-31 16:37:10', '2018-07-31 18:47:13');
INSERT INTO `sys_permission` VALUES (9, 1, 2, '[0],[2],', '业务日志', '/log', 1, '', 7, '2018-07-31 16:37:10', '2018-07-31 18:47:13');
INSERT INTO `sys_permission` VALUES (10, 1, 2, '[0],[2],', '监控管理', '/druid', 1, '', 8, '2018-07-31 16:37:10', '2018-07-31 18:47:13');
INSERT INTO `sys_permission` VALUES (11, 1, 3, '[0],[2],[3],', '用户列表', '/user/list', 0, '', 1, '2018-07-31 18:47:01', '2018-07-31 18:47:52');
INSERT INTO `sys_permission` VALUES (12, 1, 3, '[0],[2],[3],', '添加用户跳转', '/user/to_add', 0, '', 2, '2018-07-31 18:48:07', '2018-07-31 18:48:46');
INSERT INTO `sys_permission` VALUES (13, 1, 3, '[0],[2],[3],', '修改用户跳转', '/user/to_update', 0, '', 3, '2018-07-31 18:48:07', '2018-08-01 13:51:44');
INSERT INTO `sys_permission` VALUES (14, 1, 3, '[0],[2],[3],', '角色分配跳转', '/user/to_roleAssign', 0, '', 4, '2018-07-31 18:48:07', '2018-08-01 13:58:40');
INSERT INTO `sys_permission` VALUES (15, 1, 3, '[0],[2],[3],', '应用分配跳转', '/user/to_appAssign', 0, '', 5, '2018-08-01 12:46:46', '2018-08-01 13:59:06');
INSERT INTO `sys_permission` VALUES (16, 1, 3, '[0],[2],[3],', '删除用户', '/user/remove', 0, '', 6, '2018-07-31 18:48:07', '2018-08-01 14:03:24');
INSERT INTO `sys_permission` VALUES (17, 1, 3, '[0],[2],[3],', '重置密码', '/user/resetPwd', 0, '', 7, '2018-08-01 12:46:46', '2018-08-01 14:03:06');
INSERT INTO `sys_permission` VALUES (18, 1, 3, '[0],[2],[3],', '冻结用户', '/user/freeze', 0, '', 8, '2018-07-31 18:48:07', '2018-08-01 14:03:27');
INSERT INTO `sys_permission` VALUES (19, 1, 3, '[0],[2],[3],', '解除冻结用户', '/user/unfreeze', 0, '', 9, '2018-08-01 13:51:10', '2018-08-01 14:03:28');
INSERT INTO `sys_permission` VALUES (20, 1, 3, '[0],[2],[3],', '添加用户', '/user/add', 0, '', 10, '2018-07-31 18:48:07', '2018-08-01 14:03:31');
INSERT INTO `sys_permission` VALUES (21, 1, 3, '[0],[2],[3],', '修改用户', '/user/update', 0, '', 11, '2018-08-01 12:46:46', '2018-08-01 14:03:36');
INSERT INTO `sys_permission` VALUES (22, 1, 3, '[0],[2],[3],', '角色分配', '/user/setRole', 0, '', 12, '2018-07-31 18:48:07', '2018-08-01 14:03:38');
INSERT INTO `sys_permission` VALUES (23, 1, 3, '[0],[2],[3],', '应用分配', '/user/setApp', 0, '', 13, '2018-08-01 13:51:10', '2018-08-01 14:03:39');
INSERT INTO `sys_permission` VALUES (24, 1, 4, '[0],[2],[4],', '部门列表', '/dept/list', 0, '', 1, '2018-07-31 18:47:01', '2018-07-31 18:47:52');
INSERT INTO `sys_permission` VALUES (25, 1, 4, '[0],[2],[4],', '添加部门跳转', '/dept/to_add', 0, '', 2, '2018-07-31 18:48:07', '2018-07-31 18:48:46');
INSERT INTO `sys_permission` VALUES (26, 1, 4, '[0],[2],[4],', '修改部门跳转', '/dept/to_update', 0, '', 3, '2018-07-31 18:48:07', '2018-08-01 13:51:44');
INSERT INTO `sys_permission` VALUES (27, 1, 4, '[0],[2],[4],', '删除部门', '/dept/remove', 0, '', 4, '2018-07-31 18:48:07', '2018-08-01 14:03:24');
INSERT INTO `sys_permission` VALUES (28, 1, 4, '[0],[2],[4],', '添加部门', '/dept/add', 0, '', 5, '2018-07-31 18:48:07', '2018-08-01 14:03:31');
INSERT INTO `sys_permission` VALUES (29, 1, 4, '[0],[2],[4],', '修改部门', '/dept/update', 0, '', 6, '2018-08-01 12:46:46', '2018-08-01 14:03:36');
INSERT INTO `sys_permission` VALUES (30, 1, 5, '[0],[2],[5],', '角色列表', '/role/list', 0, '', 1, '2018-07-31 18:47:01', '2018-07-31 18:47:52');
INSERT INTO `sys_permission` VALUES (31, 1, 5, '[0],[2],[5],', '添加角色跳转', '/role/to_add', 0, '', 2, '2018-07-31 18:48:07', '2018-07-31 18:48:46');
INSERT INTO `sys_permission` VALUES (32, 1, 5, '[0],[2],[5],', '修改角色跳转', '/role/to_update', 0, '', 3, '2018-07-31 18:48:07', '2018-08-01 13:51:44');
INSERT INTO `sys_permission` VALUES (33, 1, 5, '[0],[2],[5],', '删除角色', '/role/remove', 0, '', 4, '2018-07-31 18:48:07', '2018-08-01 14:03:24');
INSERT INTO `sys_permission` VALUES (34, 1, 5, '[0],[2],[5],', '角色分配权限调整', '/role/to_authorityAssign', 0, '', 5, '2018-07-31 18:48:07', '2018-08-03 19:15:07');
INSERT INTO `sys_permission` VALUES (35, 1, 5, '[0],[2],[5],', '添加角色', '/role/add', 0, '', 6, '2018-07-31 18:48:07', '2018-08-01 14:03:31');
INSERT INTO `sys_permission` VALUES (36, 1, 5, '[0],[2],[5],', '修改角色', '/role/update', 0, '', 7, '2018-08-01 12:46:46', '2018-08-01 14:03:36');
INSERT INTO `sys_permission` VALUES (37, 1, 5, '[0],[2],[5],', '权限分配', '/role/setPermission', 0, '', 8, '2018-08-01 12:46:46', '2018-08-01 14:03:36');
INSERT INTO `sys_permission` VALUES (38, 1, 6, '[0],[2],[6],', '权限列表', '/permission/list', 0, '', 1, '2018-07-31 18:47:01', '2018-07-31 18:47:52');
INSERT INTO `sys_permission` VALUES (39, 1, 6, '[0],[2],[6],', '添加权限跳转', '/permission/to_add', 0, '', 2, '2018-07-31 18:48:07', '2018-07-31 18:48:46');
INSERT INTO `sys_permission` VALUES (40, 1, 6, '[0],[2],[6],', '修改权限跳转', '/permission/to_update', 0, '', 3, '2018-07-31 18:48:07', '2018-08-01 13:51:44');
INSERT INTO `sys_permission` VALUES (41, 1, 6, '[0],[2],[6],', '删除权限', '/permission/remove', 0, '', 4, '2018-07-31 18:48:07', '2018-08-01 14:03:24');
INSERT INTO `sys_permission` VALUES (42, 1, 6, '[0],[2],[6],', '添加权限', '/permission/add', 0, '', 5, '2018-07-31 18:48:07', '2018-08-01 14:03:31');
INSERT INTO `sys_permission` VALUES (43, 1, 6, '[0],[2],[6],', '修改权限', '/permission/update', 0, '', 6, '2018-08-01 12:46:46', '2018-08-01 14:03:36');
INSERT INTO `sys_permission` VALUES (44, 1, 7, '[0],[2],[7],', '应用列表', '/app/list', 0, '', 1, '2018-07-31 18:47:01', '2018-07-31 18:47:52');
INSERT INTO `sys_permission` VALUES (45, 1, 7, '[0],[2],[7],', '添加应用跳转', '/app/to_add', 0, '', 2, '2018-07-31 18:48:07', '2018-07-31 18:48:46');
INSERT INTO `sys_permission` VALUES (46, 1, 7, '[0],[2],[7],', '修改应用跳转', '/app/to_update', 0, '', 3, '2018-07-31 18:48:07', '2018-08-01 13:51:44');
INSERT INTO `sys_permission` VALUES (47, 1, 7, '[0],[2],[7],', '删除应用', '/app/remove', 0, '', 4, '2018-07-31 18:48:07', '2018-08-01 14:03:24');
INSERT INTO `sys_permission` VALUES (48, 1, 7, '[0],[2],[7],', '添加应用', '/app/add', 0, '', 5, '2018-07-31 18:48:07', '2018-08-01 14:03:31');
INSERT INTO `sys_permission` VALUES (49, 1, 7, '[0],[2],[7],', '修改应用', '/app/update', 0, '', 6, '2018-08-01 12:46:46', '2018-08-01 14:03:36');
INSERT INTO `sys_permission` VALUES (50, 1, 8, '[0],[2],[8],', '登陆日志列表', '/loginLog/list', 0, '', 1, '2018-07-31 18:47:01', '2018-07-31 18:47:52');
INSERT INTO `sys_permission` VALUES (51, 1, 8, '[0],[2],[8],', '清空登陆日志', '/loginLog/remove', 0, '', 2, '2018-07-31 18:48:07', '2018-08-01 14:03:24');
INSERT INTO `sys_permission` VALUES (52, 1, 9, '[0],[2],[9],', '日志列表', '/log/list', 0, '', 1, '2018-07-31 18:47:01', '2018-07-31 18:47:52');
INSERT INTO `sys_permission` VALUES (53, 1, 9, '[0],[2],[9],', '清空日志', '/log/remove', 0, '', 2, '2018-07-31 18:48:07', '2018-08-01 14:03:24');
COMMIT;

-- ----------------------------
-- Table structure for sys_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_role`;
CREATE TABLE `sys_role` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `app_id` int(11) DEFAULT NULL COMMENT '应用ID',
  `name` varchar(45) DEFAULT NULL COMMENT '角色名称',
  `num` tinyint(3) DEFAULT NULL COMMENT '排序',
  `gmt_create` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='角色表';

-- ----------------------------
-- Records of sys_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_role` VALUES (1, 1, '超级管理员', 1, '2018-07-31 17:05:52', '2018-07-31 17:05:57');
COMMIT;

-- ----------------------------
-- Table structure for sys_role_permission
-- ----------------------------
DROP TABLE IF EXISTS `sys_role_permission`;
CREATE TABLE `sys_role_permission` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `role_id` int(11) DEFAULT NULL COMMENT '角色ID',
  `permission_id` int(11) DEFAULT NULL COMMENT '权限ID',
  `gmt_create` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=54 DEFAULT CHARSET=utf8 COMMENT='角色权限关联表';

-- ----------------------------
-- Records of sys_role_permission
-- ----------------------------
BEGIN;
INSERT INTO `sys_role_permission` VALUES (1, 1, 1, '2018-07-31 16:35:52', '2018-07-31 16:35:52');
INSERT INTO `sys_role_permission` VALUES (2, 1, 2, '2018-07-31 16:36:39', '2018-07-31 16:36:39');
INSERT INTO `sys_role_permission` VALUES (3, 1, 3, '2018-07-31 16:37:10', '2018-07-31 18:47:13');
INSERT INTO `sys_role_permission` VALUES (4, 1, 4, '2018-07-31 16:37:10', '2018-07-31 18:47:13');
INSERT INTO `sys_role_permission` VALUES (5, 1, 5, '2018-07-31 16:37:10', '2018-07-31 18:47:13');
INSERT INTO `sys_role_permission` VALUES (6, 1, 6, '2018-07-31 16:37:10', '2018-07-31 18:47:13');
INSERT INTO `sys_role_permission` VALUES (7, 1, 7, '2018-07-31 16:37:10', '2018-07-31 18:47:13');
INSERT INTO `sys_role_permission` VALUES (8, 1, 8, '2018-07-31 16:37:10', '2018-07-31 18:47:13');
INSERT INTO `sys_role_permission` VALUES (9, 1, 9, '2018-07-31 16:37:10', '2018-07-31 18:47:13');
INSERT INTO `sys_role_permission` VALUES (10, 1, 10, '2018-07-31 16:37:10', '2018-07-31 18:47:13');
INSERT INTO `sys_role_permission` VALUES (11, 1, 11, '2018-07-31 18:47:01', '2018-07-31 18:47:52');
INSERT INTO `sys_role_permission` VALUES (12, 1, 12, '2018-07-31 18:48:07', '2018-07-31 18:48:46');
INSERT INTO `sys_role_permission` VALUES (13, 1, 13, '2018-07-31 18:48:07', '2018-08-01 13:51:44');
INSERT INTO `sys_role_permission` VALUES (14, 1, 14, '2018-07-31 18:48:07', '2018-08-01 13:58:40');
INSERT INTO `sys_role_permission` VALUES (15, 1, 15, '2018-08-01 12:46:46', '2018-08-01 13:59:06');
INSERT INTO `sys_role_permission` VALUES (16, 1, 16, '2018-07-31 18:48:07', '2018-08-01 14:03:24');
INSERT INTO `sys_role_permission` VALUES (17, 1, 17, '2018-08-01 12:46:46', '2018-08-01 14:03:06');
INSERT INTO `sys_role_permission` VALUES (18, 1, 18, '2018-07-31 18:48:07', '2018-08-01 14:03:27');
INSERT INTO `sys_role_permission` VALUES (19, 1, 19, '2018-08-01 13:51:10', '2018-08-01 14:03:28');
INSERT INTO `sys_role_permission` VALUES (20, 1, 20, '2018-07-31 18:48:07', '2018-08-01 14:03:31');
INSERT INTO `sys_role_permission` VALUES (21, 1, 21, '2018-08-01 12:46:46', '2018-08-01 14:03:36');
INSERT INTO `sys_role_permission` VALUES (22, 1, 22, '2018-07-31 18:48:07', '2018-08-01 14:03:38');
INSERT INTO `sys_role_permission` VALUES (23, 1, 23, '2018-08-01 13:51:10', '2018-08-01 14:03:39');
INSERT INTO `sys_role_permission` VALUES (24, 1, 24, '2018-07-31 18:47:01', '2018-07-31 18:47:52');
INSERT INTO `sys_role_permission` VALUES (25, 1, 25, '2018-07-31 18:48:07', '2018-07-31 18:48:46');
INSERT INTO `sys_role_permission` VALUES (26, 1, 26, '2018-07-31 18:48:07', '2018-08-01 13:51:44');
INSERT INTO `sys_role_permission` VALUES (27, 1, 27, '2018-07-31 18:48:07', '2018-08-01 14:03:24');
INSERT INTO `sys_role_permission` VALUES (28, 1, 28, '2018-07-31 18:48:07', '2018-08-01 14:03:31');
INSERT INTO `sys_role_permission` VALUES (29, 1, 29, '2018-08-01 12:46:46', '2018-08-01 14:03:36');
INSERT INTO `sys_role_permission` VALUES (30, 1, 30, '2018-07-31 18:47:01', '2018-07-31 18:47:52');
INSERT INTO `sys_role_permission` VALUES (31, 1, 31, '2018-07-31 18:48:07', '2018-07-31 18:48:46');
INSERT INTO `sys_role_permission` VALUES (32, 1, 32, '2018-07-31 18:48:07', '2018-08-01 13:51:44');
INSERT INTO `sys_role_permission` VALUES (33, 1, 33, '2018-07-31 18:48:07', '2018-08-01 14:03:24');
INSERT INTO `sys_role_permission` VALUES (34, 1, 34, '2018-07-31 18:48:07', '2018-08-01 14:03:31');
INSERT INTO `sys_role_permission` VALUES (35, 1, 35, '2018-07-31 18:48:07', '2018-08-01 14:03:31');
INSERT INTO `sys_role_permission` VALUES (36, 1, 36, '2018-08-01 12:46:46', '2018-08-01 14:03:36');
INSERT INTO `sys_role_permission` VALUES (37, 1, 37, '2018-08-01 12:46:46', '2018-08-01 14:03:36');
INSERT INTO `sys_role_permission` VALUES (38, 1, 38, '2018-07-31 18:47:01', '2018-07-31 18:47:52');
INSERT INTO `sys_role_permission` VALUES (39, 1, 39, '2018-07-31 18:48:07', '2018-07-31 18:48:46');
INSERT INTO `sys_role_permission` VALUES (40, 1, 40, '2018-07-31 18:48:07', '2018-08-01 13:51:44');
INSERT INTO `sys_role_permission` VALUES (41, 1, 41, '2018-07-31 18:48:07', '2018-08-01 14:03:24');
INSERT INTO `sys_role_permission` VALUES (42, 1, 42, '2018-07-31 18:48:07', '2018-08-01 14:03:31');
INSERT INTO `sys_role_permission` VALUES (43, 1, 43, '2018-08-01 12:46:46', '2018-08-01 14:03:36');
INSERT INTO `sys_role_permission` VALUES (44, 1, 44, '2018-07-31 18:47:01', '2018-07-31 18:47:52');
INSERT INTO `sys_role_permission` VALUES (45, 1, 45, '2018-07-31 18:48:07', '2018-07-31 18:48:46');
INSERT INTO `sys_role_permission` VALUES (46, 1, 46, '2018-07-31 18:48:07', '2018-08-01 13:51:44');
INSERT INTO `sys_role_permission` VALUES (47, 1, 47, '2018-07-31 18:48:07', '2018-08-01 14:03:24');
INSERT INTO `sys_role_permission` VALUES (48, 1, 48, '2018-07-31 18:48:07', '2018-08-01 14:03:31');
INSERT INTO `sys_role_permission` VALUES (49, 1, 49, '2018-08-01 12:46:46', '2018-08-01 14:03:36');
INSERT INTO `sys_role_permission` VALUES (50, 1, 50, '2018-07-31 18:47:01', '2018-07-31 18:47:52');
INSERT INTO `sys_role_permission` VALUES (51, 1, 51, '2018-07-31 18:48:07', '2018-08-01 14:03:24');
INSERT INTO `sys_role_permission` VALUES (52, 1, 52, '2018-07-31 18:47:01', '2018-07-31 18:47:52');
INSERT INTO `sys_role_permission` VALUES (53, 1, 53, '2018-07-31 18:48:07', '2018-08-01 14:03:24');
COMMIT;

-- ----------------------------
-- Table structure for sys_user
-- ----------------------------
DROP TABLE IF EXISTS `sys_user`;
CREATE TABLE `sys_user` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `account` varchar(32) DEFAULT NULL COMMENT '账号',
  `password` varchar(45) DEFAULT NULL COMMENT '密码',
  `salt` varchar(45) DEFAULT NULL COMMENT 'md5密码盐',
  `name` varchar(45) DEFAULT NULL COMMENT '用户姓名',
  `sex` tinyint(3) unsigned DEFAULT NULL COMMENT '性别',
  `birthday` date DEFAULT NULL COMMENT '生日',
  `phone_num` varchar(11) DEFAULT NULL COMMENT '手机号码',
  `dept_id` int(11) DEFAULT NULL COMMENT '部门ID',
  `status` tinyint(3) unsigned DEFAULT NULL COMMENT '状态',
  `gmt_create` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户表';

-- ----------------------------
-- Records of sys_user
-- ----------------------------
BEGIN;
INSERT INTO `sys_user` VALUES (1, 'admin', 'd0b9a62146ce6e1fd5f8d388afe65997', 'l2tar', '刘军', 1, '1994-01-28', '13733871170', 1, 1, '2018-07-31 16:30:30', '2018-08-08 15:52:20');
COMMIT;

-- ----------------------------
-- Table structure for sys_user_app
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_app`;
CREATE TABLE `sys_user_app` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `user_id` int(11) DEFAULT NULL COMMENT '用户ID',
  `app_id` int(11) DEFAULT NULL COMMENT '应用ID',
  `gmt_create` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户应用关联表';

-- ----------------------------
-- Records of sys_user_app
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_app` VALUES (1, 1, 1, '2018-08-07 16:14:16', '2018-08-07 16:14:16');
COMMIT;

-- ----------------------------
-- Table structure for sys_user_role
-- ----------------------------
DROP TABLE IF EXISTS `sys_user_role`;
CREATE TABLE `sys_user_role` (
  `id` int(11) unsigned NOT NULL AUTO_INCREMENT COMMENT '主键ID',
  `user_id` int(11) DEFAULT NULL COMMENT '用户ID',
  `role_id` int(11) DEFAULT NULL COMMENT '角色ID',
  `gmt_create` datetime DEFAULT CURRENT_TIMESTAMP COMMENT '创建时间',
  `gmt_modified` datetime DEFAULT CURRENT_TIMESTAMP ON UPDATE CURRENT_TIMESTAMP COMMENT '更新时间',
  PRIMARY KEY (`id`)
) ENGINE=InnoDB AUTO_INCREMENT=2 DEFAULT CHARSET=utf8 COMMENT='用户角色关联表';

-- ----------------------------
-- Records of sys_user_role
-- ----------------------------
BEGIN;
INSERT INTO `sys_user_role` VALUES (1, 1, 1, '2018-07-31 16:39:25', '2018-07-31 16:39:25');
COMMIT;

SET FOREIGN_KEY_CHECKS = 1;
